Columns

Indexes

Grants

Dependencies

Details


COLUMN_NAME DATA_TYPE NULLABLE DATA_DEFAULT COLUMN_ID COMMENTS
OBJ VARCHAR2(20 BYTE) Yes null 1 null
FILE_TAGLINE VARCHAR2(400 BYTE) Yes null 2 null
FILE_ID VARCHAR2(100 BYTE) Yes null 3 null
FILE_TYPE VARCHAR2(100 BYTE) Yes null 4 null
ALLEGATION VARCHAR2(4000 BYTE) Yes null 5 null
PARTIC_NAME VARCHAR2(4000 BYTE) Yes null 6 null
CREATED_ON DATE Yes null 7 null
CREATED_ON_FY NUMBER Yes null 8 null
INDEX_OWNER INDEX_NAME COLUMNS UNIQUENESS STATUS INDEX_TYPE TEMPORARY PARTITIONED FUNCIDX_STATUS COLUMN_EXPRESSION JOIN_INDEX




PRIVILEGE GRANTEE GRANTABLE GRANTOR OBJECT_NAME
OBJECT_ID OWNER OBJECT_TYPE OBJECT_NAME STATUS TYPE_LINK



References


NAME VALUE
CREATED 10-APR-24
LAST_DDL_TIME 07-FEB-25
OWNER QART
MVIEW_NAME MV_ALL_ALLEGATIONS
CONTAINER_NAME MV_ALL_ALLEGATIONS
QUERY SELECT      O.SID OBJ,     O.TAGLINE FILE_TAGLINE,     O.ID FILE_ID,     OT.DISPLAY FILE_TYPE,     tic.DISPLAY ALLEGATION,     SUB.SUBJECTS PARTIC_NAME, O.CREATED_ON CREATED_ON, O.CREATED_ON_FY CREATED_ON_FY FROM  MV_F_INFORMATION tfi INNER JOIN MV_INCIDENT_CATEGORIES tic ON tfi.INCIDENT = tic.SID  INNER JOIN MV_ACM_OBJ O ON tfi.OBJ = O.SID INNER JOIN  MV_ACM_OBJ_TYPE OT ON OT.SID = O.OBJ_TYPE LEFT OUTER JOIN (SELECT DISTINCT                             OBJ,                             LISTAGG (PARTIC_DISPLAY, ';' || CHR (13))                                WITHIN GROUP (ORDER BY PARTIC_DISPLAY)                                OVER (PARTITION BY OBJ)                                AS SUBJECTS                        FROM V_OBJ_PARTICIPANTS                       WHERE CODE = 'SUBJECT') SUB              ON tfi.OBJ = SUB.OBJ  WHERE OT.OBJ_TYPE_CODE IN ('FILE.INFO_INV', 'FILE.COLL_INV') UNION SELECT      O.SID OBJ,     O.TAGLINE FILE_TAGLINE,     O.ID FILE_ID,     OT.DISPLAY FILE_TYPE,     tar.DISPLAY ALLEGATION,     sub.SUBJECTS PARTIC_NAME, O.CREATED_ON CREATED_ON, O.CREATED_ON_FY CREATED_ON_FY FROM MV_F_INTAKE tfi INNER JOIN MV_ACM_OBJ O ON tfi.OBJ = O.SID INNER JOIN  MV_ACM_OBJ_TYPE OT ON OT.SID = O.OBJ_TYPE INNER JOIN MV_ACM_REFERENCE tar ON tfi.INITIAL_ALLEGATION = tar.REF_KEY LEFT OUTER JOIN (SELECT DISTINCT                             OBJ,                             LISTAGG (PARTIC_DISPLAY, ';' || CHR (13))                                WITHIN GROUP (ORDER BY PARTIC_DISPLAY)                                OVER (PARTITION BY OBJ)                                AS SUBJECTS                        FROM V_OBJ_PARTICIPANTS                       WHERE CODE = 'SUBJECT') SUB              ON tfi.OBJ = SUB.OBJ WHERE OT.OBJ_TYPE_CODE = 'FILE.INTAKE' UNION SELECT      O.SID OBJ,     O.TAGLINE FILE_TAGLINE,     O.ID FILE_ID,     OT.DISPLAY FILE_TYPE,     tar.DISPLAY ALLEGATION,     sub.SUBJECTS PARTIC_NAME, O.CREATED_ON CREATED_ON, O.CREATED_ON_FY CREATED_ON_FY FROM MV_F_THREAT_INVEST tfti INNER JOIN MV_ACM_OBJ O ON tfti.OBJ = O.SID INNER JOIN  MV_ACM_OBJ_TYPE OT ON OT.SID = O.OBJ_TYPE INNER JOIN MV_ACM_REFERENCE tar ON tfti.THREAT_CATEGORY = tar.REF_KEY LEFT OUTER JOIN (SELECT DISTINCT                             OBJ,                             LISTAGG (PARTIC_DISPLAY, ';' || CHR (13))                                WITHIN GROUP (ORDER BY PARTIC_DISPLAY)                                OVER (PARTITION BY OBJ)                                AS SUBJECTS                        FROM V_OBJ_PARTICIPANTS                       WHERE CODE = 'SUBJECT') SUB              ON tfti.OBJ = SUB.OBJ WHERE OT.OBJ_TYPE_CODE = 'FILE.THREAT_INV'
QUERY_LEN 2676
UPDATABLE N
UPDATE_LOG null
MASTER_ROLLBACK_SEG null
MASTER_LINK null
REWRITE_ENABLED N
REWRITE_CAPABILITY TEXTMATCH
REFRESH_MODE DEMAND
REFRESH_METHOD COMPLETE
BUILD_MODE IMMEDIATE
FAST_REFRESHABLE NO
LAST_REFRESH_TYPE COMPLETE
LAST_REFRESH_DATE 07-FEB-25
LAST_REFRESH_END_TIME 07-FEB-25
STALENESS NEEDS_COMPILE
AFTER_FAST_REFRESH NEEDS_COMPILE
UNKNOWN_PREBUILT N
UNKNOWN_PLSQL_FUNC N
UNKNOWN_EXTERNAL_TABLE N
UNKNOWN_CONSIDER_FRESH N
UNKNOWN_IMPORT N
UNKNOWN_TRUSTED_FD N
COMPILE_STATE NEEDS_COMPILE
USE_NO_INDEX Y
STALE_SINCE null
NUM_PCT_TABLES 0
NUM_FRESH_PCT_REGIONS null
NUM_STALE_PCT_REGIONS null
SEGMENT_CREATED YES
EVALUATION_EDITION null
UNUSABLE_BEFORE null
UNUSABLE_BEGINNING null
DEFAULT_COLLATION USING_NLS_COMP
ON_QUERY_COMPUTATION N
DUPLICATED N
SHARDED N